Relational Data Models

Back to Home

01. Learning Objective
02. Databases
03. Importance of Relational Databases
04. OLAP vs OLTP
05. Quiz 1
06. Structuring the Database: Normalization
07. Objectives of Normal Form
08. Normal Forms
09. Demo 1: Creating Normalized Tables
10. Exercise 1: Creating Normalized Tables
11. Solution: Exercise 1: Creating Normalized Tables
12. Denormalization
13. Demo 2: Creating Denormalized Tables
14. Denormalization Vs. Normalization
15. Exercise 2: Creating Denormalized Tables
16. Solution: Exercise 2: Creating Denormalized Tables
17. Fact and Dimension Tables
18. Star Schemas
19. Benefits of Star Schemas
20. Snowflake Schemas
21. Demo 3: Creating Fact and Dimension Tables
22. Exercise 3: Creating Fact and Dimension Tables
23. Solution: Exercise 3: Creating Fact and Dimension Tables
24. Data Definition and Constraints
25. Upsert
26. Conclusion

Back to Home

19. Benefits of Star Schemas

13 Benefits Of Star Schemas -

Citation for image above: https://en.wikipedia.org/wiki/Star_schema

Learn Udacity: click here to learn more :)